Tabela OncologyTreatmentPlan

Definicja tabeli OncologyTreatmentPlan

Name

OncologyTreatmentPlan

Code

OncologyTreatmentPlan

Comment

Tabela do zapisu danych dotyczacych planu terapii


Lista kolumn tabeli OncologyTreatmentPlan

Name

Code

OncologyTreatmentPlanID

OncologyTreatmentPlanID

OncologicCardID

OncologicCardID

OperationID

OperationID

RadiotherapyID

RadiotherapyID

CoordinatorDoctorID

CoordinatorDoctorID

OrdersDescrID

OrdersDescrID

POZDoctorID

POZDoctorID

OperationIssuingOrgUnitID

OperationIssuingOrgUnitID

RadiotherapyIssuingOrgUnitID

RadiotherapyIssuingOrgUnitID

ChemotherapyIssuingOrgUnitID

ChemotherapyIssuingOrgUnitID

OthersIssuingOrgUnitID

OthersIssuingOrgUnitID

TreatmentEndDecisionDocID

TreatmentEndDecisionDocID

TherapyProceeding

TherapyProceeding

TreatmentStartDT

TreatmentStartDT

TreatmentStopDT

TreatmentStopDT

POZAddress

POZAddress

TherapeuticTreatmentDescr

TherapeuticTreatmentDescr

OperationDescrID

OperationDescrID

RadiotherapyDescrID

RadiotherapyDescrID

ChemotherapyDescrID

ChemotherapyDescrID

OtherProceedingsDescrID

OtherProceedingsDescrID

EndOfTreatmentByPatRequest

EndOfTreatmentByPatRequest


Kolumna OncologyTreatmentPlanID tabeli OncologyTreatmentPlan

Definicja kolumny OncologyTreatmentPlanID tabeli OncologyTreatmentPlan

Name

OncologyTreatmentPlanID

Code

OncologyTreatmentPlanID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna OncologicCardID tabeli OncologyTreatmentPlan

Definicja kolumny OncologicCardID tabeli OncologyTreatmentPlan

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna OperationID tabeli OncologyTreatmentPlan

Definicja kolumny OperationID tabeli OncologyTreatmentPlan

Name

OperationID

Code

OperationID

Data Type

NUMBER(10)

Mandatory

No

Comment

id zabiegu operacji


Kolumna RadiotherapyID tabeli OncologyTreatmentPlan

Definicja kolumny RadiotherapyID tabeli OncologyTreatmentPlan

Name

RadiotherapyID

Code

RadiotherapyID

Data Type

NUMBER(10)

Mandatory

No

Comment

id radioterapii


Kolumna CoordinatorDoctorID tabeli OncologyTreatmentPlan

Definicja kolumny CoordinatorDoctorID tabeli OncologyTreatmentPlan

Name

CoordinatorDoctorID

Code

CoordinatorDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

id koordynatora


Kolumna OrdersDescrID tabeli OncologyTreatmentPlan

Definicja kolumny OrdersDescrID tabeli OncologyTreatmentPlan

Name

OrdersDescrID

Code

OrdersDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

zalecenia


Kolumna POZDoctorID tabeli OncologyTreatmentPlan

Definicja kolumny POZDoctorID tabeli OncologyTreatmentPlan

Name

POZDoctorID

Code

POZDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

lekarz POZ


Kolumna OperationIssuingOrgUnitID tabeli OncologyTreatmentPlan

Definicja kolumny OperationIssuingOrgUnitID tabeli OncologyTreatmentPlan

Name

OperationIssuingOrgUnitID

Code

OperationIssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

nazwa swiadczeniodawcy dla swiadczeniodawcy operacji


Kolumna RadiotherapyIssuingOrgUnitID tabeli OncologyTreatmentPlan

Definicja kolumny RadiotherapyIssuingOrgUnitID tabeli OncologyTreatmentPlan

Name

RadiotherapyIssuingOrgUnitID

Code

RadiotherapyIssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

nazwa swiadczeniodawcy dla swiadczeniodawcy radioterapii


Kolumna ChemotherapyIssuingOrgUnitID tabeli OncologyTreatmentPlan

Definicja kolumny ChemotherapyIssuingOrgUnitID tabeli OncologyTreatmentPlan

Name

ChemotherapyIssuingOrgUnitID

Code

ChemotherapyIssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

nazwa swiadczeniodawcy dla swiadczeniodawcy chemioterapii


Kolumna OthersIssuingOrgUnitID tabeli OncologyTreatmentPlan

Definicja kolumny OthersIssuingOrgUnitID tabeli OncologyTreatmentPlan

Name

OthersIssuingOrgUnitID

Code

OthersIssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

nazwa swiadczeniodawcy dla swiadczeniodawcy innych swiadczen


Kolumna TreatmentEndDecisionDocID tabeli OncologyTreatmentPlan

Definicja kolumny TreatmentEndDecisionDocID tabeli OncologyTreatmentPlan

Name

TreatmentEndDecisionDocID

Code

TreatmentEndDecisionDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TherapyProceeding tabeli OncologyTreatmentPlan

Definicja kolumny TherapyProceeding tabeli OncologyTreatmentPlan

Name

TherapyProceeding

Code

TherapyProceeding

Data Type

VARCHAR2(200)

Mandatory

No

Comment

terapia systemowa (pole tekstowe)


Kolumna TreatmentStartDT tabeli OncologyTreatmentPlan

Definicja kolumny TreatmentStartDT tabeli OncologyTreatmentPlan

Name

TreatmentStartDT

Code

TreatmentStartDT

Data Type

DATE

Mandatory

No

Comment

rozpoczecie leczenia onk


Kolumna TreatmentStopDT tabeli OncologyTreatmentPlan

Definicja kolumny TreatmentStopDT tabeli OncologyTreatmentPlan

Name

TreatmentStopDT

Code

TreatmentStopDT

Data Type

DATE

Mandatory

No

Comment

zakonczenie leczenia onk


Kolumna POZAddress tabeli OncologyTreatmentPlan

Definicja kolumny POZAddress tabeli OncologyTreatmentPlan

Name

POZAddress

Code

POZAddress

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna TherapeuticTreatmentDescr tabeli OncologyTreatmentPlan

Definicja kolumny TherapeuticTreatmentDescr tabeli OncologyTreatmentPlan

Name

TherapeuticTreatmentDescr

Code

TherapeuticTreatmentDescr

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna OperationDescrID tabeli OncologyTreatmentPlan

Definicja kolumny OperationDescrID tabeli OncologyTreatmentPlan

Name

OperationDescrID

Code

OperationDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

fk(DescriptiveData.DescriptiveDataID) zabieg operacyjny


Kolumna RadiotherapyDescrID tabeli OncologyTreatmentPlan

Definicja kolumny RadiotherapyDescrID tabeli OncologyTreatmentPlan

Name

RadiotherapyDescrID

Code

RadiotherapyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

fk(DescriptiveData.DescriptiveDataID) Radioterapia


Kolumna ChemotherapyDescrID tabeli OncologyTreatmentPlan

Definicja kolumny ChemotherapyDescrID tabeli OncologyTreatmentPlan

Name

ChemotherapyDescrID

Code

ChemotherapyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

fk(DescriptiveData.DescriptiveDataID) Chemioterapia


Kolumna OtherProceedingsDescrID tabeli OncologyTreatmentPlan

Definicja kolumny OtherProceedingsDescrID tabeli OncologyTreatmentPlan

Name

OtherProceedingsDescrID

Code

OtherProceedingsDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

fk(DescriptiveData.DescriptiveDataID)Inne np. immunoterapia lub hormonoterapia


Kolumna EndOfTreatmentByPatRequest tabeli OncologyTreatmentPlan

Definicja kolumny EndOfTreatmentByPatRequest tabeli OncologyTreatmentPlan

Name

EndOfTreatmentByPatRequest

Code

EndOfTreatmentByPatRequest

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy leczenie zostalo przerwane na zyczenie pacjenta


Lista kluczy tabeli OncologyTreatmentPlan

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyTreatmentPlan

Definicja klucza Identifier_1 tabeli OncologyTreatmentPlan

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment